How to: Set automatic page breaks.
Solution:
Click the 'View' tab from the 'Options' dialog box and select the 'Automatic Page Breaks' check box.
1) Select the 'Tools' menu and select 'Options...'. (The Options dialog box appears.)
2) Click the 'View' tab.
3) Select the 'Automatic Page Breaks' check box in the 'Windows Options' group.
the Automatic Page Breaks check box
NOTE: By default, automatic page breaks are not displayed on a worksheet until the sheet is printed or previewed for the first time. When displayed, automatic page breaks appear as dotted lines that run along gridlines.
4) Click 'OK'.
